﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Kandy/K_Master.master" AutoEventWireup="true" CodeFile="K_Req_History.aspx.cs" Inherits="Kandy_K_Req_History" %>

<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">


    <style type="text/css">
        .style2
        {
            width: 39px;
        }
        .style3
        {
            width: 194px;
        }
    </style>


</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<table width="100%">
    <tr>
        <td class="style3">
            &nbsp;</td>
        <td class="style6">
            &nbsp;</td>
        <td class="style8">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style3">
            &nbsp;</td>
        <td class="style11">
            <strong>Select Good Issu ID :</strong></td>
        <td class="style8">
            <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
                DataSourceID="SqlDataSource1" DataTextField="Issue_ID" 
                DataValueField="Issue_ID">
            </asp:DropDownList>
        </td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style3">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td class="style8">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4" colspan="4">
            <dx:ASPxGridView  ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
                ClientIDMode="AutoID" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                CssPostfix="BlackGlass" DataSourceID="SqlDataSource2" Width="100%">
                <Columns>
                    <dx:GridViewCommandColumn VisibleIndex="0">
                        <ClearFilterButton Visible="True">
                        </ClearFilterButton>
                    </dx:GridViewCommandColumn>
                    <dx:GridViewDataTextColumn FieldName="Issue_ID" 
                        VisibleIndex="0" Visible="False">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Pro_ID" VisibleIndex="1" 
                        Caption="Item ID">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Code" VisibleIndex="2" 
                        Caption="Item Code">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Sto_ID" VisibleIndex="3" 
                        Caption="Stock  ID">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Pro_Name" VisibleIndex="4" Caption="Item">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Brand_Name" VisibleIndex="5" 
                        Caption="Brand">
                    </dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="Pur_Price" ShowInCustomizationForm="True" VisibleIndex="6" 
                        Caption="Cost"></dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Ret_Price" VisibleIndex="7" 
                        Caption="Selling Price">
                    </dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="Point_Value" VisibleIndex="8" Caption="Point Value"></dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Business_Value" VisibleIndex="9" 
                        Caption="Business Value">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="Description" 
                        ShowInCustomizationForm="True" VisibleIndex="10">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn Caption="Quantity" FieldName="Qty" 
                        ShowInCustomizationForm="True" VisibleIndex="11">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="manger_status" VisibleIndex="12" 
                        Caption="Status">
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="GRN_Key" VisibleIndex="13" 
                        Visible="False">
                    </dx:GridViewDataTextColumn>
                </Columns>
                <Settings ShowFilterRow="True" />
                <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                    <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
                    </LoadingPanelOnStatusBar>
                    <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
                    </LoadingPanel>
                </Images>
                <ImagesFilterControl>
                    <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                    </LoadingPanel>
                </ImagesFilterControl>
                <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                    CssPostfix="BlackGlass">
                    <Header ImageSpacing="5px" SortingImageSpacing="5px">
                    </Header>
                </Styles>
                <StylesEditors>
                    <CalendarHeader Spacing="1px">
                    </CalendarHeader>
                    <ProgressBar Height="25px">
                    </ProgressBar>
                </StylesEditors>
            </dx:ASPxGridView>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                
                SelectCommand="SELECT Tbl_Iss_Request.Issue_ID, Tbl_Iss_Request.Pro_Name, Tbl_Iss_Request.Pur_Price, Tbl_Iss_Request.Description, Tbl_Iss_Request.Sto_ID, Tbl_Iss_Request.Qty, Tbl_Iss_Request.status, Tbl_Iss_Request.manger_status, Tbl_Iss_Request.Pro_ID, Tbl_Iss_Request.Code, Tbl_Iss_Request.GRN_Key, Tbl_Product.Brand_Name, Tbl_Product.Ret_Price, Tbl_Product.Point_Value, Tbl_Product.Business_Value FROM Tbl_Iss_Request INNER JOIN Tbl_Product ON Tbl_Iss_Request.Code = Tbl_Product.Code AND Tbl_Iss_Request.Pro_ID = Tbl_Product.Pro_ID WHERE (Tbl_Iss_Request.Issue_ID = @Issue_ID)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList1" Name="Issue_ID" 
                        PropertyName="SelectedValue" Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                
                SelectCommand="SELECT DISTINCT [Issue_ID] FROM [Tbl_Iss_Request]">
            </asp:SqlDataSource>
        </td>
    </tr>
    <tr>
        <td class="style3">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td class="style8">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style3">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td class="style8">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
</table>
</asp:Content>

